AdCourse

Logical Entity Name | AdCourse
Default Table Name | AdCourse
Physical Only | NO
Owner | dbo
Definition |
Note |

AdCourse Columns

ColumnName | Domain | Datatype | NULL | Definition
Code |  | char(12) | NO |
Descrip |  | varchar(75) | NO |
SyCampusGrpID |  | int | NO |
AdCourseTypeID |  | int | NO |
Hours |  | money | NO |
Credits |  | money | NO |
UnitType |  | char(1) | YES |
GradeLevel |  | tinyint | NO |
CatalogCode |  | varchar(10) | NO |
MinimumDays |  | smallint | NO |
MaximumDays |  | smallint | NO |
Comments |  | text | NO |
AllowOverride |  | bit | NO |
ModFlag |  | char(1) | NO |
Active |  | bit | NO |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
AdCourseID |  | int | NO |
AdDependentCourseID |  | int | NO |
Dependent |  | bit | NO |
RetakeOverride |  | bit | NO |
AdCourseLevelID |  | int | NO |
isCourseRemedial |  | bit | NO |
DefaultMaxNumOfRepeat |  | int | NO |
DefPassFailSetting |  | tinyint | NO |
CompareContactHrsWithClsSched |  | bit | NO |
EnrollStatusCredits |  | money | NO |
EnrollStatusHours |  | money | NO |
AddDropDays |  | tinyint | YES |
AddDropCalenderDays |  | bit | NO |
RetakeFee |  | bit | NO |
MaxNumWithoutRetakeFee |  | int | YES |
MinCredits |  | money | YES |
MaxCredits |  | money | YES |
MatchOverrideCredits |  | bit | NO |
IsExcludeDrops |  | bit | NO |
NumDaysExpDeadline |  | int | YES |
OutsideCourseWorkHours |  | numeric(9, 2) | NO |

AdCourse Primary and Unique Keys

Key Name | Key Type | Keys
AdCourse_AdCourseID_U_C_IDX | PrimaryKey | AdCourseID

AdCourse Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
AdCourseLevel | Non-Identifying | One To Zero or More | FK_AdCourse_AdCourseLevelID_AdCourseLevel_AdCourseLevelID |  |  | AdCourseLevelID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
AdCatalogYearCourse | Non-Identifying | One To Zero or More | FK_AdCatalogYearCourse_AdCourseID_AdCourse_AdCourseID |  |  |  | NO | YES
AdCourseAttribute | Identifying | One To Zero or More | FK_AdCourseAttribute_AdCourseID_AdCourse_AdCourseID |  |  |  | NO | YES
AdCourseBookList | Non-Identifying | One To Zero or More | FK_AdCourseBookListAdCourseID_AdCourseAdCourseID |  |  |  | NO | YES
AdCourseCoReqDetail | Non-Identifying | One To Zero or More | FK_AdCourseCoReqDetailAdCourseID_AdCourseAdCourseID |  |  |  | NO | YES
AdCourseCoReqRule | Non-Identifying | One To Zero or More | FK_AdCourseCoReqRuleAdCourseID_AdCourseAdCourseID |  |  |  | NO | YES
AdCourseCrossRef | Non-Identifying | One To Zero or More | FK_AdCourseCrossRef_AdCourseID_AdCourse_AdCourseID_U_N_IDX |  |  |  | NO | YES
AdCourseEquiv | Non-Identifying | One To Zero or More | FK_AdCourseEquiv_AdCourseID_AdCourse_AdCourseID |  |  |  | NO | YES
AdCourseEquiv | Non-Identifying | One To Zero or More | FK_AdCourseEquiv_AdEquivID_AdCourse_AdCourseID |  |  |  | NO | YES
AdCourseFeeSched | Non-Identifying | One To Zero or More | FK_AdCourseFeeSched_AdCourseID_AdCourse_AdCourseID |  |  |  | NO | YES
AdCourseGLCodeAssociation | Non-Identifying | One To Zero or More | FK_AdCourseGLCodeAssociation_AdCourseId_AdCourse_AdCourseId |  |  |  | NO | YES
AdCoursePrefixCourse | Non-Identifying | One To Zero or More | FK_AdCoursePrefixCourse_AdCourseID_AdCourse_AdCourseID |  |  |  | NO | YES
AdCoursePreReq | Non-Identifying | One To Zero or More | FK_AdCoursePreReq_AdCourseID_AdCourse_AdCourseID |  |  |  | NO | YES
AdCoursePreReq | Non-Identifying | One To Zero or More | FK_AdCoursePreReq_AdPreReqID_AdCourse_AdCourseID |  |  |  | NO | YES
AdCoursePreReqConfig | Non-Identifying | One To Zero or More | FK_AdCoursePreReqConfig_AdCourseID_AdCourse_AdCourseID |  |  |  | NO | YES
AdCoursePreReqCreditHourGrade | Non-Identifying | One To Zero or More | FK_AdCoursePreReqCreditHourGrade_AdCourseID_AdCourse_AdCourseID |  |  |  | NO | YES
AdCoursePreReqDetail | Non-Identifying | One To Zero or More | FK_AdCoursePreReqDetailAdCourseID_AdCourseAdCourseID |  |  |  | NO | YES
AdCoursePreReqNode | Non-Identifying | One To Zero or More | FK_AdCoursePreReqNode_AdCourseID_AdCourse_AdCourseID |  |  |  | NO | YES
AdCoursePreReqRule | Non-Identifying | One To Zero or More | FK_AdCoursePreReqRuleAdCourseID_AdCourseAdCourseID |  |  |  | NO | YES
AdCoursePreReqTest | Non-Identifying | One To Zero or More | FK_AdCoursePreReqTest_AdCourseID_AdCourse_AdCourseID |  |  |  | NO | YES
AdCourseSkill | Non-Identifying | One To Zero or More | FK_AdCourseSkillAdCourseId_AdCourseAdCourseId |  |  |  | NO | YES
AdEnrollDegreeAuditCourse | Non-Identifying | One To Zero or More | FK_AdEnrollDegreeAuditCourse_AdCourseID_AdCourse_AdCourseID |  |  |  | NO | YES
AdEnrollNonTermBreakInfo | Non-Identifying | One To Zero or More | FK_AdEnrollNonTermBreakInfoAdCourseID_AdCourseAdCourseID |  |  |  | NO | YES
AdEnrollSchedStatusChanges | Non-Identifying | One To Zero or More | FK_AdEnrollSchedStatusChangesAdCourseID_AdCourseAdCourseID |  |  |  | NO | YES
AdEnrollSchedStatusHistory | Non-Identifying | One To Zero or More | FK_AdEnrollSchedStatusHistory_AdCourseID_AdCourse_AdCourseID |  |  |  | NO | YES
AdInstructorCourseAssociation | Non-Identifying | One To Zero or More | FK_AdInstructorCourseAssociation_AdCourseId_AdCourse_AdCourseId |  |  |  | NO | YES
AdProgramCourse | Non-Identifying | One To Zero or More | FK_AdProgramCourse_AdCourseID_AdCourse_AdCourseID |  |  |  | NO | YES
AdSPECourseCategory | Non-Identifying | One To Zero or More | FK_AdSPECourseCategory_AdCourseID_AdCourse_AdCourseID |  |  |  | NO | YES
AdStudentTransferCourses | Non-Identifying | One To Zero or More | FK_AdStudentTransferCourses_FromAdCourseID_AdCourse_AdCourseID |  |  |  | NO | YES
AdStudentTransferCourses | Non-Identifying | One To Zero or More | FK_AdStudentTransferCourses_ToAdCourseID_AdCourse_AdCourseID |  |  |  | NO | YES
AmCollegeTransfer | Non-Identifying | One To Zero or More | FK_AmCollegeTransfer_AdCourseID_AdCourse_AdCourseID |  |  |  | NO | YES
AmCourseRel | Non-Identifying | One To Zero or More | FK_AmCourseRel.AdCourseID_AdCourse.AdCourseID |  |  |  | NO | YES
AmHighSchoolCourseRelation | Non-Identifying | One To Zero or More | FK_AmHighSchoolCourseRelationAdCourseID_AdCourseAdCourseID |  |  |  | NO | YES
AmProspectTest | Non-Identifying | One To Zero or More | FK_AmProspectTest.FailAdCourseID_AdCourse.AdCourseID |  |  |  | NO | YES
amTestByAgency | Non-Identifying | One To Zero or More | FK_AmTestByAgency.FailAdCourseID_AdCourse.AdCourseID |  |  |  | NO | YES
amTestByProgram | Non-Identifying | One To Zero or More | FK_AmTestByProgram.FailAdCourseID_AdCourse.AdCourseID |  |  |  | NO | YES
amTestByProgramConditionCourse | Non-Identifying | One To Zero or More | FK_amTestByProgramConditionCourse_adCourseId_AdCourse_AdCourseID |  |  |  | NO | YES
AmTestByProgramVersion | Non-Identifying | One To Zero or More | FK_AmTestByProgramVersion.FailAdCourseID_AdCourse.AdCourseID |  |  |  | NO | YES
amTestByProgramVersionConditionCourse | Non-Identifying | One To Zero or More | FK_amTestByProgramVersionConditionCourse_adCourseId_AdCourse_AdCourseID |  |  |  | NO | YES
CmDocumentPermit | Non-Identifying | One To Zero or More | FK_CmDocumentPermitAdCourseID_AdCourseAdCourseID |  |  |  | NO | YES
PlStudentSkill | Non-Identifying | One To Zero or More | FK_PlStudentSkill_AdCourseId_AdCourse_AdCourseId |  |  |  | NO | YES
SaAutoBillBatchDetail | Non-Identifying | One To Zero or More | FK_SaAutoBillBatchDetailAdCourseId_AdCourseAdCourseId |  |  |  | NO | YES
SaPendingChargeCourseAmount | Non-Identifying | One To Zero or More | FK_SaPendingChargeCourseAmount_AdCourseID_AdCourse_AdCourseID |  |  |  | NO | YES
SaTrans | Non-Identifying | One To Zero or More | FK_SaTrans_AdCourseID_AdCourse_AdCourseID |  |  |  | NO | YES
SaTransCourseAmount | Non-Identifying | One To Zero or More | FK_SaTransCourseAmount_AdCourseID_AdCourse_AdCourseID |  |  |  | NO | YES

AdCourse Check Constraints

Check Constraint Name | CheckConstraint

AdCourse Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group | PRIMARY

AdCourse Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.Course | NO |  |  |
Physical (Microsoft SQL Server) dbo.AdCourse | NO |  |  |

AdCourse Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | ClassScheduling
Logical | Course
Logical | CourseRegistration
Logical | DegreePathway
Logical | Documents
Logical | Grades/Attendance
Logical | LedgerCard_Billing
Logical | PreviousEd_TransferCredits
Logical | TestScores
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records

AdCourse Data Movement Rules

Name | Type | Rule Text/Value